﻿CREATE TABLE [plate].[Plate] (
    [PlateID]     INT          IDENTITY (1, 1) NOT NULL,
    [PlateTypeID] INT          NULL,
    [InventoryID] INT          NULL,
    [PlateValue]  VARCHAR (50) NULL,
    [CreatedBy]   VARCHAR (50) NULL,
    [CreatedDate] DATETIME     NULL,
    [UpdatedBy]   VARCHAR (50) NULL,
    [UpdatedDate] DATETIME     NULL,
    [EndDate]     DATETIME     NULL,
    CONSTRAINT [PK_Plate] PRIMARY KEY CLUSTERED ([PlateID] ASC),
    CONSTRAINT [FK_Plate_Inventory] FOREIGN KEY ([InventoryID]) REFERENCES [inventory].[Inventory] ([InventoryID]),
    CONSTRAINT [FK_Plate_PlateType] FOREIGN KEY ([PlateTypeID]) REFERENCES [plate].[PlateType] ([PlateTypeID])
);

